#!/bin/bash

rm -f xsmall.idx xsmall.tbl
rm -f small.idx small.tbl
rm -f medium.idx medium.tbl
rm -f large.idx large.tbl
rm -f xlarge.idx xlarge.tbl

rm -f 1.txt

./bruinbase < xsmall.sql
./bruinbase < small.sql
./bruinbase < medium.sql
./bruinbase < large.sql
./bruinbase < xlarge.sql

ls -l *.idx *.tbl >> 1.txt

echo "===1===" >> 1.txt
./bruinbase < 1.sql >> 1.txt 2>> 1.txt
echo "===2===" >> 1.txt
./bruinbase < 2.sql >> 1.txt 2>> 1.txt
echo "===3===" >> 1.txt
./bruinbase < 3.sql >> 1.txt 2>> 1.txt
echo "===4===" >> 1.txt
./bruinbase < 4.sql >> 1.txt 2>> 1.txt
echo "===5===" >> 1.txt
./bruinbase < 5.sql >> 1.txt 2>> 1.txt
echo "===6===" >> 1.txt
./bruinbase < 6.sql >> 1.txt 2>> 1.txt
echo "===7===" >> 1.txt
./bruinbase < 7.sql >> 1.txt 2>> 1.txt
echo "===8===" >> 1.txt
./bruinbase < 8.sql >> 1.txt 2>> 1.txt
echo "===9===" >> 1.txt
./bruinbase < 9.sql >> 1.txt 2>> 1.txt
echo "=======" >> 1.txt
./bruinbase < 9b.sql >> 1.txt 2>> 1.txt
echo "===10===" >> 1.txt
./bruinbase < 10.sql >> 1.txt 2>> 1.txt
echo "===11===" >> 1.txt
./bruinbase < 11.sql >> 1.txt 2>> 1.txt
echo "========" >> 1.txt
./bruinbase < 11b.sql >> 1.txt 2>> 1.txt

echo "===12===" >> 1.txt
./bruinbase < 12.sql >> 1.txt 2>> 1.txt
echo "===13===" >> 1.txt
./bruinbase < 13.sql >> 1.txt 2>> 1.txt
echo "===14===" >> 1.txt
./bruinbase < 14.sql >> 1.txt 2>> 1.txt
echo "===15===" >> 1.txt
./bruinbase < 15.sql >> 1.txt 2>> 1.txt
echo "===16===" >> 1.txt
./bruinbase < 16.sql >> 1.txt 2>> 1.txt
rm -f xsmall.idx xsmall.tbl small.idx small.tbl 
echo "===17===" >> 1.txt
./bruinbase < 17.sql >> 1.txt 2>> 1.txt
echo "===18===" >> 1.txt
./bruinbase < 18.sql >> 1.txt 2>> 1.txt
